package com.cdvtc.flower.dao;

import com.cdvtc.flower.model.Order;
import com.cdvtc.flower.model.Orderdetail;

import java.sql.SQLException;
import java.util.List;

public interface OrderDao {
    List<Order> getAllorders();

    Order getOrderById(int order_id);

    void updateOrder(Order order);

    String DeleteOrder(int order_id);

    boolean insertOrder(Order order);

    List<Order> customerOrders(int customer_id);


    void cancelOrder(int order_id);

    List<Orderdetail> getOrderdetailList(int order_id);

    void insertOrderItem(int order_id, Orderdetail orderdetail) throws SQLException;
}
